
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_AddNotice]
    (
      @param_JOL_Bulletin_Type VARCHAR(50),
      @param_JOL_Bulletin_Title VARCHAR(100),
      @param_JOL_Bulletin_Source VARCHAR(100),
      @param_JOL_Bulletin_ClickNumber INT,
      @param_JOL_Bulletin_Body NTEXT,
      @param_JOL_Bulletin_AddTime DATETIME,
      @param_JOL_Bulletin_AddUser VARCHAR(50),
      @param_JOL_Bulletin_IsSetTop BIT,
      @param_JOL_Bulletin_SubType VARCHAR(50),
      @param_JOL_Bulletin_ImageUrl VARCHAR(255)
    )
AS 
    INSERT  INTO dbo.JOL_Bulletin
            (
              JOL_Bulletin_Type,
              JOL_Bulletin_Title,
              JOL_Bulletin_Source,
              JOL_Bulletin_ClickNumber,
              JOL_Bulletin_Body,
              JOL_Bulletin_AddTime,
              JOL_Bulletin_AddUser,
              JOL_Bulletin_UpdateTime,
              JOL_Bulletin_UpdateUser,
              JOL_Bulletin_IsSetTop,
              JOL_Bulletin_SubType,
              JOL_Bulletin_ImageUrl
            )
    VALUES  (
              @param_JOL_Bulletin_Type, -- JOL_Bulletin_Type - varchar(50)
              @param_JOL_Bulletin_Title, -- JOL_Bulletin_Title - varchar(100)
              @param_JOL_Bulletin_Source, -- JOL_Bulletin_Source - varchar(100)
              0, -- JOL_Bulletin_ClickNumber - int
              @param_JOL_Bulletin_Body, -- JOL_Bulletin_Body - ntext
              GETDATE(), -- JOL_Bulletin_AddTime - datetime
              @param_JOL_Bulletin_AddUser, -- JOL_Bulletin_AddUser - varchar(50)
              NULL, -- JOL_Bulletin_UpdateTime - datetime
              '', -- JOL_Bulletin_UpdateUser - varchar(50)
              @param_JOL_Bulletin_IsSetTop, -- JOL_Bulletin_IsSetTop - bit
              @param_JOL_Bulletin_SubType, -- JOL_Bulletin_SubType - varchar(50)
              @param_JOL_Bulletin_ImageUrl  -- JOL_Bulletin_ImageUrl - varchar(255)
            )
GO
